Creating a Bar Chart with a table of statistical data aligned with the bars is a popular topic. With SAS 9.4, creating such graphs gets easier with the new AXISTABLE statement in GTL and SG procedures. But some use cases can flummox the latest gizmos. Such is the case I ran into recently. Here
The SGPLOT procedure supports a wide variety of plot types that you can use directly or combine together to create more complex graphs. Even with this flexibility, there might be times you run across a graph that you cannot create using one of the standard plot types. An "area" bar
I recently had a discussion with a friend, and we were wondering about Apple's market share. This led me to look into the actual data ... finding the online charts lacking, and then designing my own charts. Follow along if you're curious about the process of improving the charts, or
A dual response axis chart is useful when the data type for the multiple measures are not compatible. For example, when overlaying measures like "This Year" sales with "Last Year" sales, the format and magnitudes of the two measures (or values for two groups) may be compatible, and it is
Bar charts in SGPLOT procedure have some new features that everyone may not be familiar with. In this article we will create bar charts with color response on linear axes. Normally, the VBAR statement treats the x-axis as discrete, placing each unique value by itself, equally spaced on the x-axis.
As Sheldon Cooper would say, this is the first episode of "Fun with Charts". I did not find a cool term like "Vexillology" and "Cartography" is taken by map making, so let us go with "Chartology". Yesterday, I saw a couple of interesting bar charts as shown on the right. I thought
Recently, a user posed a question on how to plot stacked frequencies on a time axis. The data included frequencies of different viruses by week. The data is modified to preserve confidentiality and is shown below. The user's first instinct was to use a bar chart with stacked groups. This works for automatically computing frequencies
A couple of weeks back I described q way to create a Schedule Chart using the SGPLOT procedure. In that case, I used the HIGHLOW plot to draw bar segments, both for a single and grouped case. A natural extension is to create one with links between each segment. So,
Do you know how to create a bar chart using SAS, and when to use what kind of bar chart?!? If the answer doesn't come to you "easy as pie" then this blog is for you! Below are several examples of different kinds of bar charts you can create with SAS/GRAPH.
Creating bar charts with group classification is very easy using the SG procedures. When using a group variable, the group values for each category are stacked by default. Using the sashelp.prdsale data set and default STAT of SUM, here is the graph and the code. SGPLOT code: proc sgplot data=sashelp.prdsale;
Recently a reader chimed in with a question on the Do Loop article by Rick Wicklin on how to create a bar chart with percent statistics. Rick used SAS 9.3 and the reader wanted to do the same with SAS 9.2. For the basic (non-grouped) bar chart, the process is the
A commonly requested graph is a bar chart with response and targets. With SAS 9.3, the SGPLOT procedure supports new "parametric" plot statements called HBARPARM and VBARPARM. These statements are special versions of the HBAR and VBAR statements and they expect summarized data for each category or category+group combination. Also,
It seemed like an easy task. A SAS user asked me how to use the SGPLOT procedure to create a bar chart where the vertical axis shows percentages instead of counts. I assumed that there was some simple option that would change the scale of the vertical axis from counts
As a practitioner of visual analytics, I read the featured blog of ‘Visualizations: Comparing Tableau, SPSS, R, Excel, Matlab, JS, Python, SAS’ last year with great interest. In the post, the blogger Tim Matteson asked the readers to guess which software was used to create his 18 graphs. My buddy,
Recently a user was working with the HBAR statement with cluster groups with SG procedures. User wanted to see the group values on the axis. SGPLOT does not display multi level axes as these are shared with different plot types. However, with SGPLOT, there is often a way to get
Back in late 2012 I discussed a technique for Conditional Highlighting, where additional attributes can be displayed in a graph. In the previous article the goal was to display a graph of Response by Year by Drug. We used a cluster grouped bar chart to create the bar chart. We
To get into the mood for this blog post, you should first listen to the music video of The Who singing My Generation... I guess everybody has 'their generation' and here in the U.S. the most famous generation has been the Baby Boomers. Many companies have tried to design products they
A recent question by a user lead led me to experiment with what is often referred to as conditional highlighting. The user wanted to display a bar chart of response by year, where each bar is colored by year, and show a cross hatch pattern on the bars where the
When comparing results by category and group, putting the items to be compared close together usually leads to a graph that is easier to decode. Take the case of the data (simulated) shown below. Here we have population by age group and sex. To compare the population by sex, it is
ODS Graphics have matured. With SAS 9.2, GTL and SG procedures were a new direction for creating analytical graphs in SAS. The motivation and design of the GTL framework and the SG procedures was driven primarily by the needs of the procedure writers within SAS to enable the automatic creation
The topic of cluster groups comes up often. By cluster group I am referring to the feature in bar charts where the group values are displayed side by side. With SAS 9.3, SG Procedures support stack or cluster grouping for Bar Charts and overlay or cluster grouping for all other
In this blog we have been discussing graphs useful for analysis of data for many domains such as clinical research, forecasting and more. SG Procedures and GTL are particularly suited for these use cases. So, when I came upon a dashboard image from Steven Few's Visual Business Intelligence blog, showing the
Assigning observations into clusters can be challenging. One challenge is deciding how many clusters are in the data. Another is identifying which observations are potentially misclassified because they are on the boundary between two different clusters. Ralph Abbey's 2019 paper ("How to Evaluate Different Clustering Results") is a good way
Data is crucial for the development of artificial intelligence (AI) applications. However, the rapid availability of data is a challenge due to increasingly strict privacy regulations. A possible solution is to use synthetic data. Gartner predicts by 2024 that 60% of the data used to develop AI and analytics applications
Data visualization has never been more widespread and consumed by a global audience as it has been this year with the Coronavirus pandemic. One visualization that is commonly used to display metrics of Coronavirus is a bar line chart where the bars display the actual values and the line is a moving average metric.
Adverse outcomes, and the rapid spread of COVID-19, have accelerated research on all aspects of the disease. You may have found it overwhelming, and very time-consuming, to find relevant and specialized insights in all the scientific literature out there. To aid researchers in quickly identifying relevant literature about key topics
As we continue to process and understand the ongoing effects of the novel coronavirus, many of us have grown used to viewing COVID-19 dashboards and visualizations, including this popular coronavirus dashboard from SAS. If you are more accustomed to building graphs and visualizations using the SGPLOT and SGPANEL procedures, this
Ever since automated machine learning has entered the scene, people are asking, "Will automated machine learning replace data scientists?"
With the US census coming in 2020, I've decided to sharpen my skills at graphing census data. And today I'm working on creating a population pyramid chart to analyze the age and gender distribution. Follow along if you'd like to see how to create such a chart ... or jump
You might have noticed I've been trying out SAS ODS Graphics lately, whereas in the past I mainly used SAS/Graph for my samples. In this blog post I step you through my latest fancy SGplot graph - hopefully you'll learn some tips & techniques, as you follow along. (I don't
